--გრაფიკი და CPV კოდი მისათითებელია ფინანსურში

Declare @ContractID UniqueIdentifier, @CurrentDate DateTime

Set @ContractID = '16FE798F-FBF1-410C-AB0A-12AA7320754F'
Set @CurrentDate = '2014-07-03 21:00:00.000'

Select * From dbo.BL_Liabilities Where LiabilityNumber = 25057 And ContractID = @ContractID

Select TreasuryID, TreasuryStatusID, TreasuryChangeDescription, * From dbo.BL_Contracts
Where ContractNumber = N'სე/018–0611' And ID = @ContractID




Select * From dbo.BL_TreasuryContractShedule
Where DateDeleted Is Null And ContractID = @ContractID
Order By MonthIndex

Select * From dbo.BL_TreasuryContractCpvCodes
Where DateDeleted Is Null And ContractID = @ContractID
